CREATE TABLE [dbo].[JY_Award]
(
[JY_Award_ID] [int] NOT NULL IDENTITY(1, 1),
[JY_Award_Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Award_Level] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Award_Type] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Award_Time] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Award_Unit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Award_Add_Time] [datetime] NULL,
[JY_Student_No] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JY_Award_Remark] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JY_Award] ADD CONSTRAINT [PK_JY_Award] PRIMARY KEY CLUSTERED  ([JY_Award_ID]) ON [PRIMARY]
GO
